UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZmJSu3dvWfvM855N9ZOhXr1d11Gr4MTqKy9Th+6vLAU='
WHERE
key_id = '0b4b5a1a9b326316206006a2230d3fa50804d8ae438323d55e5cfc10b95aac14'
AND (
token = 'ZmJSu3dvWfvM855N9ZOhXr1d11Gr4MTqKy9Th+6vLAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)