UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MNP4oXSz6leYGS8oU8EHt04F8CMODlD59ExpT7U/hBA='
WHERE
key_id = '627fdc52e42df1dd5e618e75e262e20f8bf1aa4eef2c6ee0941588f6580854b5'
AND (
token = 'MNP4oXSz6leYGS8oU8EHt04F8CMODlD59ExpT7U/hBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)