UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qVpgzoU6jaL69xJ4rk880gN9RIxMAJuCo2XWXS/svks='
WHERE
key_id = '678ddfa66d9611f65027d60e8ae4f49e9b53f90bd35e8abca8586f3253759067'
AND (
token = 'qVpgzoU6jaL69xJ4rk880gN9RIxMAJuCo2XWXS/svks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)