UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IzXl3X90TVKldB5JDMLYVkA1GIQrLQPcR7eNCgfnvWs='
WHERE
key_id = '9594c0302fa0434cd380a9284a60401aaab88490596b39cdfae44323ac830e49'
AND (
token = 'IzXl3X90TVKldB5JDMLYVkA1GIQrLQPcR7eNCgfnvWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)