UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3sYE9m9VVYD/1yzISBM40Yw47jB4xlt4p7dVVzciRLA='
WHERE
key_id = '1585445b0ae1d2bf15d90b93082029c8c9a882f52afd5069776a72d23facf445'
AND (
token = '3sYE9m9VVYD/1yzISBM40Yw47jB4xlt4p7dVVzciRLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)