UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UpRE9jitgmMq93QynUuSIKq+FwjRsa/8LTREBlS6hmg='
WHERE
key_id = '7aff93a0d0378ec14975fac49a1078c305220470ea7e0073868943944560690e'
AND (
token = 'UpRE9jitgmMq93QynUuSIKq+FwjRsa/8LTREBlS6hmg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)