UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i8kqyiyxGf6c5yDn23TZ8b9DPqsDzO5VoQe73c4B8Gc='
WHERE
key_id = '548031d8d531bd442e6f6a8bcaa8a6c0f137baa07204351a0b84649f1f6003b7'
AND (
token = 'i8kqyiyxGf6c5yDn23TZ8b9DPqsDzO5VoQe73c4B8Gc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)