UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NkC70h0oSwaJKDNYABOHdNe4kfH3AW+57EzNDGf6w0o='
WHERE
key_id = '2ce3dd6465dfbbcecc7130d64e47a8914bd95d10d37167a2804e8da1e16711a3'
AND (
token = 'NkC70h0oSwaJKDNYABOHdNe4kfH3AW+57EzNDGf6w0o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)