UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hOQ6ebJ0OJJOgSGb5cD5MRf/OxLjxrmW9ygP9IIB3R8='
WHERE
key_id = '38a85024d1757267a403656d70cd95fbf2b8da414f92a5e19d7eca4e0df3019c'
AND (
token = 'hOQ6ebJ0OJJOgSGb5cD5MRf/OxLjxrmW9ygP9IIB3R8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)