UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wHZXwhNoogrRFd/MapSVUG3Kbz9UC/IIsErARrRhJM8='
WHERE
key_id = '93de383c1f6256a7592b72b6bdbba39236f2ac6236265b9f9641aa5759601eed'
AND (
token = 'wHZXwhNoogrRFd/MapSVUG3Kbz9UC/IIsErARrRhJM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)