UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'by++GHl547EM5bWXfDmqnLy/c8K+oaURp+5paNjU/hc='
WHERE
key_id = 'd731cd86714b6f1fc3cbf7fc05f888658ce189c7804a017a4542ce6e14f38a50'
AND (
token = 'by++GHl547EM5bWXfDmqnLy/c8K+oaURp+5paNjU/hc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)