UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o8iN3yeCuJDJnCPpMKW6Qs0Bx0gFQYVRoyn4HojT1Ns='
WHERE
key_id = '7f3f5383e7660101d44179c2000ba631096883a458de3d74e807c552151cc66c'
AND (
token = 'o8iN3yeCuJDJnCPpMKW6Qs0Bx0gFQYVRoyn4HojT1Ns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)