UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M00pfG6tRjqVEvebwQaYw0m+55Ozyz3K4bv5dC228mo='
WHERE
key_id = '332be5318a2c855170c06d80e291d2617efa9a65002c199af9525df8591919dc'
AND (
token = 'M00pfG6tRjqVEvebwQaYw0m+55Ozyz3K4bv5dC228mo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)