UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DK0Z/ri3aYnJDEqD4rPpkcHRAcxkhRDmxQUXza8vaYU='
WHERE
key_id = 'ac8af4ef5f1589355e1f6b7ea9c8cbaca396a0e00f38c9a11635fa867f0132b8'
AND (
token = 'DK0Z/ri3aYnJDEqD4rPpkcHRAcxkhRDmxQUXza8vaYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)