UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3kn5o4+jL2DiZ17O0/bux4NT54QjEvwrTuZMJWR6BVs='
WHERE
key_id = 'd8af0e2fe638e23ddb877a5b60a16695078d98571c115de32332e8e234ed36af'
AND (
token = '3kn5o4+jL2DiZ17O0/bux4NT54QjEvwrTuZMJWR6BVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)