UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SCh/NEhMej5+04cq1bpLUO4eDta3TsemC6esK7dKWsE='
WHERE
key_id = 'f5baef12e79920c804dc4d88df08ac0fc286945bc4b264cf6dd7a40e171f3d6a'
AND (
token = 'SCh/NEhMej5+04cq1bpLUO4eDta3TsemC6esK7dKWsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)