UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SQsSEwKvCV9ivk2jvvHBwK/B3onLqgnKDLF77v/h3rs='
WHERE
key_id = 'ccfb565f0c6b5a578e822b599607eb7fe7294d2550746f3c3bb6806484b421e1'
AND (
token = 'SQsSEwKvCV9ivk2jvvHBwK/B3onLqgnKDLF77v/h3rs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)