UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TN9jiKDpg173wriY+G4Wl43API/fBCJXN0PtE8Er+DM='
WHERE
key_id = 'b5a1a25ea775a22aa59bf4d5fab1145dcd92e5c8fb1a6b9f2efe64a2f95b5e6d'
AND (
token = 'TN9jiKDpg173wriY+G4Wl43API/fBCJXN0PtE8Er+DM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)