UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pEHtiqr0F6y90bM331RHXQbj/WYF4AuGFsZ1ZmuRPlU='
WHERE
key_id = 'f8f586b28e636fa103c524176f5dcf36374fb23d6b9103239d879376e0b7641d'
AND (
token = 'pEHtiqr0F6y90bM331RHXQbj/WYF4AuGFsZ1ZmuRPlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)