UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z5n9C8Am3Tl86z3kT5J9PKbxmCHyu72W9nbRZIa+om0='
WHERE
key_id = 'cb24016ae901d87460995345929eed1554f59f3284037048bb7459adebcc8c3b'
AND (
token = 'Z5n9C8Am3Tl86z3kT5J9PKbxmCHyu72W9nbRZIa+om0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)