UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HSTlCE71Jwhyd4OU06xl2qiLX67aKRV1YvujW9fVqKk='
WHERE
key_id = '64e8f661cb6994183f6f15974cd3f85ac1756a3fa37c8df51db2af1b2f8c1e69'
AND (
token = 'HSTlCE71Jwhyd4OU06xl2qiLX67aKRV1YvujW9fVqKk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)