UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NXo9knvZqftBD1WDlLY3CNBcwrgcXU+ntR61DxAVWJ8='
WHERE
key_id = '8e899036a24a85ce66a21ff4bbb90b5a0b05c5166ae5a94dee5d3d29fae3e9d3'
AND (
token = 'NXo9knvZqftBD1WDlLY3CNBcwrgcXU+ntR61DxAVWJ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)