UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'odKCAKQkIjWZ74cNrESmG7fm44tedGPIRMwHniupp5Y='
WHERE
key_id = 'a27b1db594bb8b2e526b2c7036ada3b9ee5a2406fa59b25f631dcc994e108c1f'
AND (
token = 'odKCAKQkIjWZ74cNrESmG7fm44tedGPIRMwHniupp5Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)