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