UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kAHtPXi/QVNkBhGqbS6V+Pd+oqhKjhSuRWxZ2k8Ry9Y='
WHERE
key_id = '7b0b22630692c34373d6786a9028b88fd57f2842c0d37e3b61f17d224cf4c2be'
AND (
token = 'kAHtPXi/QVNkBhGqbS6V+Pd+oqhKjhSuRWxZ2k8Ry9Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)