UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'buQq7HADjOW1zWV3qU+JeaPpOJgOmTOQTr2wdtQcRro='
WHERE
key_id = '3b5daa19f1786c64f15bf2f044bb302e67a41de173a05b690b403211dc71766f'
AND (
token = 'buQq7HADjOW1zWV3qU+JeaPpOJgOmTOQTr2wdtQcRro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)