UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MprdeZBMhc25Se9uBbkkq9mTFH4GCwpsDwfishpUH4o='
WHERE
key_id = '10028068399dd97bfb6fccdf4e3f47def78ed885dda50082e33e4e2ad00263a8'
AND (
token = 'MprdeZBMhc25Se9uBbkkq9mTFH4GCwpsDwfishpUH4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)