UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1oHlwPTWMJuBOQJ72beUEkEoO0r+Q9Kk5rTKXQh+JXo='
WHERE
key_id = 'f54973d23284702f2e64adbf460071ffbc4aab122781cc14ceb6739e2a90fee6'
AND (
token = '1oHlwPTWMJuBOQJ72beUEkEoO0r+Q9Kk5rTKXQh+JXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)