UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3AEX9gwA2aGPrfv0Qb2Ok3i51u4zlGtJs7gnvPG2ohU='
WHERE
key_id = '8ee918d23e25b99599f572e95821b4ae97ccb541875799395cf013174e288b9b'
AND (
token = '3AEX9gwA2aGPrfv0Qb2Ok3i51u4zlGtJs7gnvPG2ohU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)