UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9gAxEbsTCnUjQPGYHrl7qiVP9NSLHZorUq5/+Mmmczo='
WHERE
key_id = '12a2f42265f2eae0b775da9934373d1d16d52e5fe8610cb6085728c778262caa'
AND (
token = '9gAxEbsTCnUjQPGYHrl7qiVP9NSLHZorUq5/+Mmmczo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)