UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mZI5r8JbsJv5HFtHb0MueqBMSVOP9ix+wewgBqV5Xek='
WHERE
key_id = 'f89ba6d699d4b4f4da899556f72c59f1256bec7801da72cca65eff81f2b0984f'
AND (
token = 'mZI5r8JbsJv5HFtHb0MueqBMSVOP9ix+wewgBqV5Xek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)