UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zQl0yMy2Q2Z0+cLFQYTLlzzl7rIdFOF2c0qUdIpW4oc='
WHERE
key_id = '4e530e88c78d21c2a18424820bef368d4ad09ba56b003bf389998b688e9dee53'
AND (
token = 'zQl0yMy2Q2Z0+cLFQYTLlzzl7rIdFOF2c0qUdIpW4oc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)